
SET IDENTITY_INSERT [party].[party] ON
GO
 
 
PRINT 'Inserting values into [party]'

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO [party].[party] ([PartyId],[PartyTypeId],[CreatedBy],[CreatedDateTime],[UpdatedBy],[UpdatedDateTime],[RowTimestamp])VALUES(1,1,'chrisgraham',getdate(),'chrisgraham',getdate(),DEFAULT)
INSERT INTO [party].[party] ([PartyId],[PartyTypeId],[CreatedBy],[CreatedDateTime],[UpdatedBy],[UpdatedDateTime],[RowTimestamp])VALUES(2,1,'ChrisGraham',getdate(),'ChrisGraham',getdate(),DEFAULT)
INSERT INTO [party].[party] ([PartyId],[PartyTypeId],[CreatedBy],[CreatedDateTime],[UpdatedBy],[UpdatedDateTime],[RowTimestamp])VALUES(3,1,'ChrisGraham',getdate(),'ChrisGraham',getdate(),DEFAULT)

PRINT 'Done'
 
 
SET IDENTITY_INSERT [party].[party] OFF
GO



INSERT INTO [party].[individualparty] ([PartyId],[GivenName], [MiddleName], [FamilyName],[GenderId],[DateOfBirth],[DateOfDeath],[OccupationId],[MaritalStatusId],[CreatedBy],[CreatedDateTime],[UpdatedBy],[UpdatedDateTime],[RowTimestamp])
VALUES(1,'Kevin', '' ,'Jones',1,NULL,NULL,NULL,NULL,'chrisgraham',getdate(),'chrisgraham',getdate(),DEFAULT)

INSERT INTO [party].[individualparty] ([PartyId],[GivenName], [MiddleName], [FamilyName],[GenderId],[DateOfBirth],[DateOfDeath],[OccupationId],[MaritalStatusId],[CreatedBy],[CreatedDateTime],[UpdatedBy],[UpdatedDateTime],[RowTimestamp])
VALUES(2,'David', '' ,'Pritchard',1,NULL,NULL,NULL,NULL,'chrisgraham',getdate(),'chrisgraham',getdate(),DEFAULT)

INSERT INTO [party].[individualparty] ([PartyId],[GivenName], [MiddleName], [FamilyName],[GenderId],[DateOfBirth],[DateOfDeath],[OccupationId],[MaritalStatusId],[CreatedBy],[CreatedDateTime],[UpdatedBy],[UpdatedDateTime],[RowTimestamp])
VALUES(3,'Chris', '' ,'Graham',1,NULL,NULL,NULL,NULL,'chrisgraham',getdate(),'chrisgraham',getdate(),DEFAULT)

